Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 3312 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 595.2 KiB |
| Average record size in memory | 184.0 B |
Variable types
| Numeric | 8 |
|---|---|
| Categorical | 14 |
| DateTime | 1 |
Country has constant value "United States" | Constant |
Order Date Year has constant value "2020" | Constant |
Order ID has a high cardinality: 1687 distinct values | High cardinality |
Customer ID has a high cardinality: 693 distinct values | High cardinality |
Customer Name has a high cardinality: 693 distinct values | High cardinality |
City has a high cardinality: 350 distinct values | High cardinality |
Product ID has a high cardinality: 1525 distinct values | High cardinality |
Product Name has a high cardinality: 1511 distinct values | High cardinality |
Postal Code is highly overall correlated with State and 1 other fields | High correlation |
Sales is highly overall correlated with Profit | High correlation |
Discount is highly overall correlated with Profit and 1 other fields | High correlation |
Profit is highly overall correlated with Sales and 2 other fields | High correlation |
Profit Margin is highly overall correlated with Discount and 1 other fields | High correlation |
State is highly overall correlated with Postal Code and 1 other fields | High correlation |
Region is highly overall correlated with Postal Code and 1 other fields | High correlation |
Category is highly overall correlated with Sub-Category | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Product ID is uniformly distributed | Uniform |
Product Name is uniformly distributed | Uniform |
Row ID has unique values | Unique |
Discount has 1590 (48.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-03 09:03:43.219042 |
|---|---|
| Analysis finished | 2023-05-03 09:04:28.153229 |
| Duration | 44.93 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Row ID
Real number (ℝ)
| Distinct | 3312 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5087.1075 |
| Minimum | 13 |
|---|---|
| Maximum | 9994 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 13 |
|---|---|
| 5-th percentile | 643.55 |
| Q1 | 2655.75 |
| median | 5183.5 |
| Q3 | 7498.25 |
| 95-th percentile | 9471.45 |
| Maximum | 9994 |
| Range | 9981 |
| Interquartile range (IQR) | 4842.5 |
Descriptive statistics
| Standard deviation | 2817.4823 |
|---|---|
| Coefficient of variation (CV) | 0.5538476 |
| Kurtosis | -1.1809217 |
| Mean | 5087.1075 |
| Median Absolute Deviation (MAD) | 2409.5 |
| Skewness | -0.016172898 |
| Sum | 16848500 |
| Variance | 7938206.3 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 1 | < 0.1% |
| 6694 | 1 | < 0.1% |
| 6671 | 1 | < 0.1% |
| 6680 | 1 | < 0.1% |
| 6681 | 1 | < 0.1% |
| 6682 | 1 | < 0.1% |
| 6683 | 1 | < 0.1% |
| 6689 | 1 | < 0.1% |
| 6690 | 1 | < 0.1% |
| 6691 | 1 | < 0.1% |
| Other values (3302) | 3302 |
| Value | Count | Frequency (%) |
| 13 | 1 | |
| 24 | 1 | |
| 35 | 1 | |
| 42 | 1 | |
| 44 | 1 | |
| 72 | 1 | |
| 76 | 1 | |
| 77 | 1 | |
| 78 | 1 | |
| 85 | 1 |
| Value | Count | Frequency (%) |
| 9994 | 1 | |
| 9993 | 1 | |
| 9992 | 1 | |
| 9991 | 1 | |
| 9989 | 1 | |
| 9988 | 1 | |
| 9982 | 1 | |
| 9970 | 1 | |
| 9969 | 1 | |
| 9968 | 1 |
Order ID
Categorical
| Distinct | 1687 |
|---|---|
| Distinct (%) | 50.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| CA-2017-100111 | 14 |
|---|---|
| CA-2017-157987 | 12 |
| CA-2017-140949 | 9 |
| CA-2017-117457 | 9 |
| CA-2017-156776 | 8 |
| Other values (1682) |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Characters and Unicode
| Total characters | 46368 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 875 ? |
|---|---|
| Unique (%) | 26.4% |
Sample
| 1st row | CA-2017-114412 |
|---|---|
| 2nd row | US-2017-156909 |
| 3rd row | CA-2017-107727 |
| 4th row | CA-2017-120999 |
| 5th row | CA-2017-139619 |
Common Values
| Value | Count | Frequency (%) |
| CA-2017-100111 | 14 | 0.4% |
| CA-2017-157987 | 12 | 0.4% |
| CA-2017-140949 | 9 | 0.3% |
| CA-2017-117457 | 9 | 0.3% |
| CA-2017-156776 | 8 | 0.2% |
| CA-2017-118017 | 8 | 0.2% |
| CA-2017-140872 | 8 | 0.2% |
| CA-2017-102925 | 8 | 0.2% |
| CA-2017-110905 | 8 | 0.2% |
| CA-2017-113278 | 8 | 0.2% |
| Other values (1677) | 3220 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ca-2017-100111 | 14 | 0.4% |
| ca-2017-157987 | 12 | 0.4% |
| ca-2017-140949 | 9 | 0.3% |
| ca-2017-117457 | 9 | 0.3% |
| ca-2017-110905 | 8 | 0.2% |
| us-2017-118087 | 8 | 0.2% |
| ca-2017-161956 | 8 | 0.2% |
| ca-2017-164756 | 8 | 0.2% |
| ca-2017-113278 | 8 | 0.2% |
| ca-2017-102925 | 8 | 0.2% |
| Other values (1677) | 3220 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 8448 | |
| - | 6624 | |
| 0 | 5199 | |
| 2 | 5169 | |
| 7 | 4664 | |
| C | 2732 | 5.9% |
| A | 2732 | 5.9% |
| 4 | 1809 | 3.9% |
| 6 | 1769 | 3.8% |
| 3 | 1739 | 3.8% |
| Other values (5) | 5483 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 33120 | |
| Dash Punctuation | 6624 | 14.3% |
| Uppercase Letter | 6624 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 8448 | |
| 0 | 5199 | |
| 2 | 5169 | |
| 7 | 4664 | |
| 4 | 1809 | 5.5% |
| 6 | 1769 | 5.3% |
| 3 | 1739 | 5.3% |
| 5 | 1673 | 5.1% |
| 8 | 1344 | 4.1% |
| 9 | 1306 | 3.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2732 | |
| A | 2732 | |
| U | 580 | 8.8% |
| S | 580 | 8.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6624 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 39744 | |
| Latin | 6624 | 14.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 8448 | |
| - | 6624 | |
| 0 | 5199 | |
| 2 | 5169 | |
| 7 | 4664 | |
| 4 | 1809 | 4.6% |
| 6 | 1769 | 4.5% |
| 3 | 1739 | 4.4% |
| 5 | 1673 | 4.2% |
| 8 | 1344 | 3.4% |
Latin
| Value | Count | Frequency (%) |
| C | 2732 | |
| A | 2732 | |
| U | 580 | 8.8% |
| S | 580 | 8.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46368 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 8448 | |
| - | 6624 | |
| 0 | 5199 | |
| 2 | 5169 | |
| 7 | 4664 | |
| C | 2732 | 5.9% |
| A | 2732 | 5.9% |
| 4 | 1809 | 3.9% |
| 6 | 1769 | 3.8% |
| 3 | 1739 | 3.8% |
| Other values (5) | 5483 |
Order Date
Date
| Distinct | 322 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2020-12-30 00:00:00 |
Histogram with fixed size bins (bins=50)
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 186 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.748188 |
| Min length | 8 |
Characters and Unicode
| Total characters | 42222 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Standard Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 1897 | |
| Second Class | 657 | 19.8% |
| First Class | 572 | 17.3% |
| Same Day | 186 | 5.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 3126 | |
| standard | 1897 | |
| second | 657 | 9.9% |
| first | 572 | 8.6% |
| same | 186 | 2.8% |
| day | 186 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7292 | |
| s | 6824 | |
| d | 4451 | |
| 3312 | ||
| l | 3126 | |
| C | 3126 | |
| S | 2740 | 6.5% |
| n | 2554 | 6.0% |
| r | 2469 | 5.8% |
| t | 2469 | 5.8% |
| Other values (8) | 3859 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 32286 | |
| Uppercase Letter | 6624 | 15.7% |
| Space Separator | 3312 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7292 | |
| s | 6824 | |
| d | 4451 | |
| l | 3126 | |
| n | 2554 | 7.9% |
| r | 2469 | 7.6% |
| t | 2469 | 7.6% |
| e | 843 | 2.6% |
| c | 657 | 2.0% |
| o | 657 | 2.0% |
| Other values (3) | 944 | 2.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 3126 | |
| S | 2740 | |
| F | 572 | 8.6% |
| D | 186 | 2.8% |
Space Separator
| Value | Count | Frequency (%) |
| 3312 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 38910 | |
| Common | 3312 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7292 | |
| s | 6824 | |
| d | 4451 | |
| l | 3126 | |
| C | 3126 | |
| S | 2740 | 7.0% |
| n | 2554 | 6.6% |
| r | 2469 | 6.3% |
| t | 2469 | 6.3% |
| e | 843 | 2.2% |
| Other values (7) | 3016 |
Common
| Value | Count | Frequency (%) |
| 3312 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42222 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 7292 | |
| s | 6824 | |
| d | 4451 | |
| 3312 | ||
| l | 3126 | |
| C | 3126 | |
| S | 2740 | 6.5% |
| n | 2554 | 6.0% |
| r | 2469 | 5.8% |
| t | 2469 | 5.8% |
| Other values (8) | 3859 |
Customer ID
Categorical
| Distinct | 693 |
|---|---|
| Distinct (%) | 20.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| SV-20365 | 20 |
|---|---|
| JL-15835 | 20 |
| Dp-13240 | 19 |
| MH-18115 | 19 |
| LC-16870 | 17 |
| Other values (688) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 26496 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 96 ? |
|---|---|
| Unique (%) | 2.9% |
Sample
| 1st row | AA-10480 |
|---|---|
| 2nd row | SF-20065 |
| 3rd row | MA-17560 |
| 4th row | LC-16930 |
| 5th row | ES-14080 |
Common Values
| Value | Count | Frequency (%) |
| SV-20365 | 20 | 0.6% |
| JL-15835 | 20 | 0.6% |
| Dp-13240 | 19 | 0.6% |
| MH-18115 | 19 | 0.6% |
| LC-16870 | 17 | 0.5% |
| SS-20140 | 16 | 0.5% |
| AC-10615 | 16 | 0.5% |
| JM-15250 | 15 | 0.5% |
| EP-13915 | 15 | 0.5% |
| DS-13030 | 15 | 0.5% |
| Other values (683) | 3140 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sv-20365 | 20 | 0.6% |
| jl-15835 | 20 | 0.6% |
| dp-13240 | 19 | 0.6% |
| mh-18115 | 19 | 0.6% |
| lc-16870 | 17 | 0.5% |
| ss-20140 | 16 | 0.5% |
| ac-10615 | 16 | 0.5% |
| jm-15250 | 15 | 0.5% |
| ep-13915 | 15 | 0.5% |
| ds-13030 | 15 | 0.5% |
| Other values (683) | 3140 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 4014 | |
| - | 3312 | |
| 0 | 2857 | 10.8% |
| 5 | 2602 | 9.8% |
| 2 | 1533 | 5.8% |
| 8 | 998 | 3.8% |
| 3 | 993 | 3.7% |
| 6 | 921 | 3.5% |
| 9 | 890 | 3.4% |
| 4 | 878 | 3.3% |
| Other values (29) | 7498 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 16560 | |
| Uppercase Letter | 6603 | 24.9% |
| Dash Punctuation | 3312 | 12.5% |
| Lowercase Letter | 21 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 610 | 9.2% |
| C | 574 | 8.7% |
| B | 552 | 8.4% |
| M | 528 | 8.0% |
| D | 465 | 7.0% |
| J | 409 | 6.2% |
| A | 385 | 5.8% |
| H | 343 | 5.2% |
| P | 330 | 5.0% |
| R | 299 | 4.5% |
| Other values (16) | 2108 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4014 | |
| 0 | 2857 | |
| 5 | 2602 | |
| 2 | 1533 | 9.3% |
| 8 | 998 | 6.0% |
| 3 | 993 | 6.0% |
| 6 | 921 | 5.6% |
| 9 | 890 | 5.4% |
| 4 | 878 | 5.3% |
| 7 | 874 | 5.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 19 | |
| l | 2 | 9.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3312 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 19872 | |
| Latin | 6624 | 25.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 610 | 9.2% |
| C | 574 | 8.7% |
| B | 552 | 8.3% |
| M | 528 | 8.0% |
| D | 465 | 7.0% |
| J | 409 | 6.2% |
| A | 385 | 5.8% |
| H | 343 | 5.2% |
| P | 330 | 5.0% |
| R | 299 | 4.5% |
| Other values (18) | 2129 |
Common
| Value | Count | Frequency (%) |
| 1 | 4014 | |
| - | 3312 | |
| 0 | 2857 | |
| 5 | 2602 | |
| 2 | 1533 | 7.7% |
| 8 | 998 | 5.0% |
| 3 | 993 | 5.0% |
| 6 | 921 | 4.6% |
| 9 | 890 | 4.5% |
| 4 | 878 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26496 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 4014 | |
| - | 3312 | |
| 0 | 2857 | 10.8% |
| 5 | 2602 | 9.8% |
| 2 | 1533 | 5.8% |
| 8 | 998 | 3.8% |
| 3 | 993 | 3.7% |
| 6 | 921 | 3.5% |
| 9 | 890 | 3.4% |
| 4 | 878 | 3.3% |
| Other values (29) | 7498 |
Customer Name
Categorical
| Distinct | 693 |
|---|---|
| Distinct (%) | 20.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Seth Vernon | 20 |
|---|---|
| John Lee | 20 |
| Dean percer | 19 |
| Mick Hernandez | 19 |
| Lena Cacioppo | 17 |
| Other values (688) |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.979469 |
| Min length | 7 |
Characters and Unicode
| Total characters | 42988 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 96 ? |
|---|---|
| Unique (%) | 2.9% |
Sample
| 1st row | Andrew Allen |
|---|---|
| 2nd row | Sandra Flanagan |
| 3rd row | Matt Abelman |
| 4th row | Linda Cazamias |
| 5th row | Erin Smith |
Common Values
| Value | Count | Frequency (%) |
| Seth Vernon | 20 | 0.6% |
| John Lee | 20 | 0.6% |
| Dean percer | 19 | 0.6% |
| Mick Hernandez | 19 | 0.6% |
| Lena Cacioppo | 17 | 0.5% |
| Saphhira Shifley | 16 | 0.5% |
| Ann Chong | 16 | 0.5% |
| Janet Martin | 15 | 0.5% |
| Emily Phan | 15 | 0.5% |
| Darrin Sayre | 15 | 0.5% |
| Other values (683) | 3140 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| frank | 49 | 0.7% |
| patrick | 42 | 0.6% |
| john | 41 | 0.6% |
| michael | 39 | 0.6% |
| ann | 38 | 0.6% |
| bill | 36 | 0.5% |
| alan | 34 | 0.5% |
| rick | 33 | 0.5% |
| mick | 31 | 0.5% |
| dean | 30 | 0.5% |
| Other values (829) | 6281 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3965 | 9.2% |
| e | 3905 | 9.1% |
| n | 3495 | 8.1% |
| 3342 | 7.8% | |
| r | 3111 | 7.2% |
| i | 2632 | 6.1% |
| l | 2124 | 4.9% |
| o | 2024 | 4.7% |
| t | 1738 | 4.0% |
| s | 1541 | 3.6% |
| Other values (46) | 15111 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 32760 | |
| Uppercase Letter | 6814 | 15.9% |
| Space Separator | 3342 | 7.8% |
| Other Punctuation | 62 | 0.1% |
| Dash Punctuation | 10 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3965 | |
| e | 3905 | |
| n | 3495 | |
| r | 3111 | |
| i | 2632 | 8.0% |
| l | 2124 | 6.5% |
| o | 2024 | 6.2% |
| t | 1738 | 5.3% |
| s | 1541 | 4.7% |
| h | 1306 | 4.0% |
| Other values (17) | 6919 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 620 | 9.1% |
| S | 610 | 9.0% |
| B | 573 | 8.4% |
| M | 550 | 8.1% |
| D | 482 | 7.1% |
| J | 409 | 6.0% |
| A | 400 | 5.9% |
| H | 358 | 5.3% |
| P | 330 | 4.8% |
| R | 310 | 4.5% |
| Other values (16) | 2172 |
Space Separator
| Value | Count | Frequency (%) |
| 3342 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 62 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 39574 | |
| Common | 3414 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3965 | 10.0% |
| e | 3905 | 9.9% |
| n | 3495 | 8.8% |
| r | 3111 | 7.9% |
| i | 2632 | 6.7% |
| l | 2124 | 5.4% |
| o | 2024 | 5.1% |
| t | 1738 | 4.4% |
| s | 1541 | 3.9% |
| h | 1306 | 3.3% |
| Other values (43) | 13733 |
Common
| Value | Count | Frequency (%) |
| 3342 | ||
| ' | 62 | 1.8% |
| - | 10 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42967 | |
| None | 21 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3965 | 9.2% |
| e | 3905 | 9.1% |
| n | 3495 | 8.1% |
| 3342 | 7.8% | |
| r | 3111 | 7.2% |
| i | 2632 | 6.1% |
| l | 2124 | 4.9% |
| o | 2024 | 4.7% |
| t | 1738 | 4.0% |
| s | 1541 | 3.6% |
| Other values (44) | 15090 |
None
| Value | Count | Frequency (%) |
| ö | 18 | |
| ü | 3 | 14.3% |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.897343 |
| Min length | 8 |
Characters and Unicode
| Total characters | 29468 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Home Office |
| 4th row | Corporate |
| 5th row | Corporate |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 1668 | |
| Corporate | 980 | |
| Home Office | 664 | 20.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 1668 | |
| corporate | 980 | |
| home | 664 | 16.7% |
| office | 664 | 16.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 4292 | |
| e | 3976 | |
| r | 3628 | |
| C | 2648 | |
| m | 2332 | |
| n | 1668 | 5.7% |
| s | 1668 | 5.7% |
| u | 1668 | 5.7% |
| f | 1328 | 4.5% |
| t | 980 | 3.3% |
| Other values (7) | 5280 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 24828 | |
| Uppercase Letter | 3976 | 13.5% |
| Space Separator | 664 | 2.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 4292 | |
| e | 3976 | |
| r | 3628 | |
| m | 2332 | |
| n | 1668 | 6.7% |
| s | 1668 | 6.7% |
| u | 1668 | 6.7% |
| f | 1328 | 5.3% |
| t | 980 | 3.9% |
| p | 980 | 3.9% |
| Other values (3) | 2308 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2648 | |
| H | 664 | 16.7% |
| O | 664 | 16.7% |
Space Separator
| Value | Count | Frequency (%) |
| 664 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 28804 | |
| Common | 664 | 2.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 4292 | |
| e | 3976 | |
| r | 3628 | |
| C | 2648 | |
| m | 2332 | |
| n | 1668 | 5.8% |
| s | 1668 | 5.8% |
| u | 1668 | 5.8% |
| f | 1328 | 4.6% |
| t | 980 | 3.4% |
| Other values (6) | 4616 |
Common
| Value | Count | Frequency (%) |
| 664 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 29468 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 4292 | |
| e | 3976 | |
| r | 3628 | |
| C | 2648 | |
| m | 2332 | |
| n | 1668 | 5.7% |
| s | 1668 | 5.7% |
| u | 1668 | 5.7% |
| f | 1328 | 4.5% |
| t | 980 | 3.3% |
| Other values (7) | 5280 |
Country
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Characters and Unicode
| Total characters | 43056 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 3312 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 3312 | |
| states | 3312 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9936 | |
| e | 6624 | |
| U | 3312 | 7.7% |
| n | 3312 | 7.7% |
| i | 3312 | 7.7% |
| d | 3312 | 7.7% |
| 3312 | 7.7% | |
| S | 3312 | 7.7% |
| a | 3312 | 7.7% |
| s | 3312 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 33120 | |
| Uppercase Letter | 6624 | 15.4% |
| Space Separator | 3312 | 7.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 9936 | |
| e | 6624 | |
| n | 3312 | 10.0% |
| i | 3312 | 10.0% |
| d | 3312 | 10.0% |
| a | 3312 | 10.0% |
| s | 3312 | 10.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 3312 | |
| S | 3312 |
Space Separator
| Value | Count | Frequency (%) |
| 3312 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 39744 | |
| Common | 3312 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 9936 | |
| e | 6624 | |
| U | 3312 | 8.3% |
| n | 3312 | 8.3% |
| i | 3312 | 8.3% |
| d | 3312 | 8.3% |
| S | 3312 | 8.3% |
| a | 3312 | 8.3% |
| s | 3312 | 8.3% |
Common
| Value | Count | Frequency (%) |
| 3312 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43056 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 9936 | |
| e | 6624 | |
| U | 3312 | 7.7% |
| n | 3312 | 7.7% |
| i | 3312 | 7.7% |
| d | 3312 | 7.7% |
| 3312 | 7.7% | |
| S | 3312 | 7.7% |
| a | 3312 | 7.7% |
| s | 3312 | 7.7% |
City
Categorical
| Distinct | 350 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| New York City | |
|---|---|
| Los Angeles | 210 |
| San Francisco | 190 |
| Seattle | 182 |
| Philadelphia | 182 |
| Other values (345) |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 9.3179348 |
| Min length | 4 |
Characters and Unicode
| Total characters | 30861 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 86 ? |
|---|---|
| Unique (%) | 2.6% |
Sample
| 1st row | Concord |
|---|---|
| 2nd row | Philadelphia |
| 3rd row | Houston |
| 4th row | Naperville |
| 5th row | Melbourne |
Common Values
| Value | Count | Frequency (%) |
| New York City | 306 | 9.2% |
| Los Angeles | 210 | 6.3% |
| San Francisco | 190 | 5.7% |
| Seattle | 182 | 5.5% |
| Philadelphia | 182 | 5.5% |
| Chicago | 114 | 3.4% |
| Houston | 104 | 3.1% |
| Columbus | 82 | 2.5% |
| Dallas | 70 | 2.1% |
| Jacksonville | 45 | 1.4% |
| Other values (340) | 1827 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| city | 327 | 7.1% |
| new | 314 | 6.8% |
| york | 308 | 6.7% |
| san | 246 | 5.3% |
| los | 210 | 4.5% |
| angeles | 210 | 4.5% |
| francisco | 190 | 4.1% |
| seattle | 182 | 3.9% |
| philadelphia | 182 | 3.9% |
| chicago | 114 | 2.5% |
| Other values (371) | 2340 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2941 | 9.5% |
| a | 2553 | 8.3% |
| o | 2391 | 7.7% |
| l | 2098 | 6.8% |
| i | 2094 | 6.8% |
| n | 1997 | 6.5% |
| t | 1522 | 4.9% |
| s | 1508 | 4.9% |
| r | 1446 | 4.7% |
| 1311 | 4.2% | |
| Other values (40) | 11000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 24927 | |
| Uppercase Letter | 4623 | 15.0% |
| Space Separator | 1311 | 4.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2941 | |
| a | 2553 | |
| o | 2391 | |
| l | 2098 | 8.4% |
| i | 2094 | 8.4% |
| n | 1997 | 8.0% |
| t | 1522 | 6.1% |
| s | 1508 | 6.0% |
| r | 1446 | 5.8% |
| c | 844 | 3.4% |
| Other values (15) | 5533 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 707 | |
| S | 586 | |
| L | 392 | |
| N | 365 | |
| A | 347 | 7.5% |
| P | 340 | 7.4% |
| Y | 313 | 6.8% |
| F | 311 | 6.7% |
| D | 188 | 4.1% |
| M | 174 | 3.8% |
| Other values (14) | 900 |
Space Separator
| Value | Count | Frequency (%) |
| 1311 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 29550 | |
| Common | 1311 | 4.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2941 | 10.0% |
| a | 2553 | 8.6% |
| o | 2391 | 8.1% |
| l | 2098 | 7.1% |
| i | 2094 | 7.1% |
| n | 1997 | 6.8% |
| t | 1522 | 5.2% |
| s | 1508 | 5.1% |
| r | 1446 | 4.9% |
| c | 844 | 2.9% |
| Other values (39) | 10156 |
Common
| Value | Count | Frequency (%) |
| 1311 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30861 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 2941 | 9.5% |
| a | 2553 | 8.3% |
| o | 2391 | 7.7% |
| l | 2098 | 6.8% |
| i | 2094 | 6.8% |
| n | 1997 | 6.5% |
| t | 1522 | 4.9% |
| s | 1508 | 4.9% |
| r | 1446 | 4.7% |
| 1311 | 4.2% | |
| Other values (40) | 11000 |
State
Categorical
| Distinct | 47 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Washington | |
| Pennsylvania | |
| Other values (42) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.5389493 |
| Min length | 4 |
Characters and Unicode
| Total characters | 28281 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North Carolina |
|---|---|
| 2nd row | Pennsylvania |
| 3rd row | Texas |
| 4th row | Illinois |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 663 | |
| New York | 352 | 10.6% |
| Texas | 317 | 9.6% |
| Washington | 215 | 6.5% |
| Pennsylvania | 197 | 5.9% |
| Illinois | 172 | 5.2% |
| Ohio | 161 | 4.9% |
| Florida | 126 | 3.8% |
| North Carolina | 85 | 2.6% |
| Tennessee | 81 | 2.4% |
| Other values (37) | 943 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| california | 663 | |
| new | 424 | 10.9% |
| york | 352 | 9.1% |
| texas | 317 | 8.2% |
| washington | 215 | 5.6% |
| pennsylvania | 197 | 5.1% |
| illinois | 172 | 4.4% |
| ohio | 161 | 4.2% |
| florida | 126 | 3.3% |
| carolina | 93 | 2.4% |
| Other values (41) | 1153 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 3522 | |
| i | 3235 | |
| n | 2820 | 10.0% |
| o | 2493 | 8.8% |
| r | 1764 | 6.2% |
| e | 1715 | 6.1% |
| l | 1596 | 5.6% |
| s | 1578 | 5.6% |
| C | 853 | 3.0% |
| f | 665 | 2.4% |
| Other values (36) | 8040 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23849 | |
| Uppercase Letter | 3871 | 13.7% |
| Space Separator | 561 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 3522 | |
| i | 3235 | |
| n | 2820 | |
| o | 2493 | |
| r | 1764 | |
| e | 1715 | |
| l | 1596 | |
| s | 1578 | |
| f | 665 | 2.8% |
| h | 658 | 2.8% |
| Other values (14) | 3803 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 853 | |
| N | 532 | |
| T | 398 | |
| Y | 352 | |
| I | 278 | 7.2% |
| W | 252 | 6.5% |
| M | 247 | 6.4% |
| O | 208 | 5.4% |
| P | 197 | 5.1% |
| F | 126 | 3.3% |
| Other values (11) | 428 |
Space Separator
| Value | Count | Frequency (%) |
| 561 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27720 | |
| Common | 561 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 3522 | |
| i | 3235 | |
| n | 2820 | 10.2% |
| o | 2493 | 9.0% |
| r | 1764 | 6.4% |
| e | 1715 | 6.2% |
| l | 1596 | 5.8% |
| s | 1578 | 5.7% |
| C | 853 | 3.1% |
| f | 665 | 2.4% |
| Other values (35) | 7479 |
Common
| Value | Count | Frequency (%) |
| 561 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28281 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 3522 | |
| i | 3235 | |
| n | 2820 | 10.0% |
| o | 2493 | 8.8% |
| r | 1764 | 6.2% |
| e | 1715 | 6.1% |
| l | 1596 | 5.6% |
| s | 1578 | 5.6% |
| C | 853 | 3.0% |
| f | 665 | 2.4% |
| Other values (36) | 8040 |
Postal Code
Real number (ℝ)
| Distinct | 437 |
|---|---|
| Distinct (%) | 13.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56186.515 |
| Minimum | 1841 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 1841 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 27978.75 |
| median | 60472.5 |
| Q3 | 90032 |
| 95-th percentile | 98103 |
| Maximum | 99301 |
| Range | 97460 |
| Interquartile range (IQR) | 62053.25 |
Descriptive statistics
| Standard deviation | 31980.376 |
|---|---|
| Coefficient of variation (CV) | 0.5691824 |
| Kurtosis | -1.4592121 |
| Mean | 56186.515 |
| Median Absolute Deviation (MAD) | 29576.5 |
| Skewness | -0.16255089 |
| Sum | 1.8608974 × 108 |
| Variance | 1.0227444 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10035 | 89 | 2.7% |
| 10009 | 81 | 2.4% |
| 10024 | 73 | 2.2% |
| 98105 | 71 | 2.1% |
| 94122 | 70 | 2.1% |
| 94110 | 67 | 2.0% |
| 10011 | 63 | 1.9% |
| 98103 | 63 | 1.9% |
| 94109 | 53 | 1.6% |
| 19140 | 52 | 1.6% |
| Other values (427) | 2630 |
| Value | Count | Frequency (%) |
| 1841 | 12 | |
| 1852 | 7 | |
| 2038 | 2 | 0.1% |
| 2138 | 2 | 0.1% |
| 2149 | 9 | |
| 2169 | 3 | 0.1% |
| 2740 | 4 | 0.1% |
| 2886 | 3 | 0.1% |
| 2895 | 2 | 0.1% |
| 2908 | 7 |
| Value | Count | Frequency (%) |
| 99301 | 2 | 0.1% |
| 99207 | 4 | 0.1% |
| 98661 | 1 | < 0.1% |
| 98632 | 2 | 0.1% |
| 98502 | 2 | 0.1% |
| 98226 | 3 | 0.1% |
| 98208 | 1 | < 0.1% |
| 98115 | 48 | |
| 98105 | 71 | |
| 98103 | 63 |
Region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8611111 |
| Min length | 4 |
Characters and Unicode
| Total characters | 16100 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | East |
| 3rd row | Central |
| 4th row | Central |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 1095 | |
| East | 921 | |
| Central | 778 | |
| South | 518 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 1095 | |
| east | 921 | |
| central | 778 | |
| south | 518 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 3312 | |
| s | 2016 | |
| e | 1873 | |
| a | 1699 | |
| W | 1095 | 6.8% |
| E | 921 | 5.7% |
| C | 778 | 4.8% |
| n | 778 | 4.8% |
| r | 778 | 4.8% |
| l | 778 | 4.8% |
| Other values (4) | 2072 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12788 | |
| Uppercase Letter | 3312 | 20.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 3312 | |
| s | 2016 | |
| e | 1873 | |
| a | 1699 | |
| n | 778 | 6.1% |
| r | 778 | 6.1% |
| l | 778 | 6.1% |
| o | 518 | 4.1% |
| u | 518 | 4.1% |
| h | 518 | 4.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 1095 | |
| E | 921 | |
| C | 778 | |
| S | 518 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 16100 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 3312 | |
| s | 2016 | |
| e | 1873 | |
| a | 1699 | |
| W | 1095 | 6.8% |
| E | 921 | 5.7% |
| C | 778 | 4.8% |
| n | 778 | 4.8% |
| r | 778 | 4.8% |
| l | 778 | 4.8% |
| Other values (4) | 2072 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16100 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 3312 | |
| s | 2016 | |
| e | 1873 | |
| a | 1699 | |
| W | 1095 | 6.8% |
| E | 921 | 5.7% |
| C | 778 | 4.8% |
| n | 778 | 4.8% |
| r | 778 | 4.8% |
| l | 778 | 4.8% |
| Other values (4) | 2072 |
Product ID
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 1525 |
|---|---|
| Distinct (%) | 46.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| FUR-CH-10003774 | 8 |
|---|---|
| OFF-ST-10001325 | 7 |
| TEC-AC-10003832 | 7 |
| OFF-BI-10004632 | 7 |
| OFF-PA-10003673 | 7 |
| Other values (1520) |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 49680 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 554 ? |
|---|---|
| Unique (%) | 16.7% |
Sample
| 1st row | OFF-PA-10002365 |
|---|---|
| 2nd row | FUR-CH-10002774 |
| 3rd row | OFF-PA-10000249 |
| 4th row | TEC-PH-10004093 |
| 5th row | OFF-ST-10003282 |
Common Values
| Value | Count | Frequency (%) |
| FUR-CH-10003774 | 8 | 0.2% |
| OFF-ST-10001325 | 7 | 0.2% |
| TEC-AC-10003832 | 7 | 0.2% |
| OFF-BI-10004632 | 7 | 0.2% |
| OFF-PA-10003673 | 7 | 0.2% |
| OFF-ST-10003208 | 7 | 0.2% |
| OFF-PA-10001970 | 7 | 0.2% |
| TEC-AC-10004510 | 7 | 0.2% |
| OFF-BI-10003274 | 6 | 0.2% |
| FUR-TA-10001520 | 6 | 0.2% |
| Other values (1515) | 3243 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| fur-ch-10003774 | 8 | 0.2% |
| off-st-10003208 | 7 | 0.2% |
| tec-ac-10004510 | 7 | 0.2% |
| off-pa-10001970 | 7 | 0.2% |
| off-st-10001325 | 7 | 0.2% |
| off-pa-10003673 | 7 | 0.2% |
| tec-ac-10003832 | 7 | 0.2% |
| off-bi-10004632 | 7 | 0.2% |
| off-bi-10002012 | 6 | 0.2% |
| off-st-10000615 | 6 | 0.2% |
| Other values (1515) | 3243 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11602 | |
| - | 6624 | |
| F | 5070 | |
| 1 | 5029 | |
| O | 2100 | 4.2% |
| 4 | 1644 | 3.3% |
| 3 | 1608 | 3.2% |
| 2 | 1598 | 3.2% |
| A | 1496 | 3.0% |
| C | 1111 | 2.2% |
| Other values (17) | 11798 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 26496 | |
| Uppercase Letter | 16560 | |
| Dash Punctuation | 6624 | 13.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 5070 | |
| O | 2100 | |
| A | 1496 | 9.0% |
| C | 1111 | 6.7% |
| U | 1061 | 6.4% |
| T | 1016 | 6.1% |
| R | 968 | 5.8% |
| P | 918 | 5.5% |
| E | 695 | 4.2% |
| B | 576 | 3.5% |
| Other values (6) | 1549 | 9.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11602 | |
| 1 | 5029 | |
| 4 | 1644 | 6.2% |
| 3 | 1608 | 6.1% |
| 2 | 1598 | 6.0% |
| 5 | 1094 | 4.1% |
| 7 | 1018 | 3.8% |
| 9 | 978 | 3.7% |
| 6 | 976 | 3.7% |
| 8 | 949 | 3.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6624 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 33120 | |
| Latin | 16560 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 5070 | |
| O | 2100 | |
| A | 1496 | 9.0% |
| C | 1111 | 6.7% |
| U | 1061 | 6.4% |
| T | 1016 | 6.1% |
| R | 968 | 5.8% |
| P | 918 | 5.5% |
| E | 695 | 4.2% |
| B | 576 | 3.5% |
| Other values (6) | 1549 | 9.4% |
Common
| Value | Count | Frequency (%) |
| 0 | 11602 | |
| - | 6624 | |
| 1 | 5029 | |
| 4 | 1644 | 5.0% |
| 3 | 1608 | 4.9% |
| 2 | 1598 | 4.8% |
| 5 | 1094 | 3.3% |
| 7 | 1018 | 3.1% |
| 9 | 978 | 3.0% |
| 6 | 976 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 49680 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11602 | |
| - | 6624 | |
| F | 5070 | |
| 1 | 5029 | |
| O | 2100 | 4.2% |
| 4 | 1644 | 3.3% |
| 3 | 1608 | 3.2% |
| 2 | 1598 | 3.2% |
| A | 1496 | 3.0% |
| C | 1111 | 2.2% |
| Other values (17) | 11798 |
Category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.815217 |
| Min length | 9 |
Characters and Unicode
| Total characters | 42444 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Office Supplies |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Technology |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 2002 | |
| Furniture | 686 | 20.7% |
| Technology | 624 | 18.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 2002 | |
| supplies | 2002 | |
| furniture | 686 | 12.9% |
| technology | 624 | 11.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5314 | |
| i | 4690 | |
| p | 4004 | |
| f | 4004 | |
| u | 3374 | 7.9% |
| c | 2626 | 6.2% |
| l | 2626 | 6.2% |
| O | 2002 | 4.7% |
| s | 2002 | 4.7% |
| S | 2002 | 4.7% |
| Other values (10) | 9800 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35128 | |
| Uppercase Letter | 5314 | 12.5% |
| Space Separator | 2002 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5314 | |
| i | 4690 | |
| p | 4004 | |
| f | 4004 | |
| u | 3374 | |
| c | 2626 | |
| l | 2626 | |
| s | 2002 | 5.7% |
| r | 1372 | 3.9% |
| n | 1310 | 3.7% |
| Other values (5) | 3806 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 2002 | |
| S | 2002 | |
| F | 686 | 12.9% |
| T | 624 | 11.7% |
Space Separator
| Value | Count | Frequency (%) |
| 2002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 40442 | |
| Common | 2002 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 5314 | |
| i | 4690 | |
| p | 4004 | |
| f | 4004 | |
| u | 3374 | |
| c | 2626 | 6.5% |
| l | 2626 | 6.5% |
| O | 2002 | 5.0% |
| s | 2002 | 5.0% |
| S | 2002 | 5.0% |
| Other values (9) | 7798 |
Common
| Value | Count | Frequency (%) |
| 2002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42444 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 5314 | |
| i | 4690 | |
| p | 4004 | |
| f | 4004 | |
| u | 3374 | 7.9% |
| c | 2626 | 6.2% |
| l | 2626 | 6.2% |
| O | 2002 | 4.7% |
| s | 2002 | 4.7% |
| S | 2002 | 4.7% |
| Other values (10) | 9800 |
Sub-Category
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.1887077 |
| Min length | 3 |
Characters and Unicode
| Total characters | 23809 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Paper |
|---|---|
| 2nd row | Chairs |
| 3rd row | Paper |
| 4th row | Phones |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 500 | |
| Paper | 459 | |
| Furnishings | 316 | |
| Phones | 294 | |
| Storage | 288 | |
| Art | 282 | |
| Accessories | 275 | |
| Chairs | 190 | 5.7% |
| Appliances | 165 | 5.0% |
| Labels | 114 | 3.4% |
| Other values (7) | 429 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| binders | 500 | |
| paper | 459 | |
| furnishings | 316 | |
| phones | 294 | |
| storage | 288 | |
| art | 282 | |
| accessories | 275 | |
| chairs | 190 | 5.7% |
| appliances | 165 | 5.0% |
| labels | 114 | 3.4% |
| Other values (7) | 429 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 3289 | |
| e | 2934 | |
| r | 2396 | 10.1% |
| i | 1876 | 7.9% |
| n | 1759 | 7.4% |
| a | 1493 | 6.3% |
| o | 1102 | 4.6% |
| p | 1000 | 4.2% |
| h | 833 | 3.5% |
| c | 824 | 3.5% |
| Other values (18) | 6303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 20497 | |
| Uppercase Letter | 3312 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 3289 | |
| e | 2934 | |
| r | 2396 | |
| i | 1876 | |
| n | 1759 | |
| a | 1493 | |
| o | 1102 | 5.4% |
| p | 1000 | 4.9% |
| h | 833 | 4.1% |
| c | 824 | 4.0% |
| Other values (8) | 2991 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 753 | |
| A | 722 | |
| B | 576 | |
| F | 380 | |
| S | 347 | |
| C | 212 | 6.4% |
| L | 114 | 3.4% |
| T | 104 | 3.1% |
| E | 71 | 2.1% |
| M | 33 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23809 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 3289 | |
| e | 2934 | |
| r | 2396 | 10.1% |
| i | 1876 | 7.9% |
| n | 1759 | 7.4% |
| a | 1493 | 6.3% |
| o | 1102 | 4.6% |
| p | 1000 | 4.2% |
| h | 833 | 3.5% |
| c | 824 | 3.5% |
| Other values (18) | 6303 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 23809 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 3289 | |
| e | 2934 | |
| r | 2396 | 10.1% |
| i | 1876 | 7.9% |
| n | 1759 | 7.4% |
| a | 1493 | 6.3% |
| o | 1102 | 4.6% |
| p | 1000 | 4.2% |
| h | 833 | 3.5% |
| c | 824 | 3.5% |
| Other values (18) | 6303 |
Product Name
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 1511 |
|---|---|
| Distinct (%) | 45.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| Easy-staple paper | 16 |
|---|---|
| Staples | 15 |
| Staples in misc. colors | 12 |
| Staple envelope | 11 |
| Storex Dura Pro Binders | 8 |
| Other values (1506) |
Length
| Max length | 127 |
|---|---|
| Median length | 77 |
| Mean length | 37.051329 |
| Min length | 5 |
Characters and Unicode
| Total characters | 122714 |
|---|---|
| Distinct characters | 84 |
| Distinct categories | 12 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 554 ? |
|---|---|
| Unique (%) | 16.7% |
Sample
| 1st row | Xerox 1967 |
|---|---|
| 2nd row | Global Deluxe Stacking Chair, Gray |
| 3rd row | Easy-staple paper |
| 4th row | Panasonic Kx-TS550 |
| 5th row | Advantus 10-Drawer Portable Organizer, Chrome Metal Frame, Smoke Drawers |
Common Values
| Value | Count | Frequency (%) |
| Easy-staple paper | 16 | 0.5% |
| Staples | 15 | 0.5% |
| Staples in misc. colors | 12 | 0.4% |
| Staple envelope | 11 | 0.3% |
| Storex Dura Pro Binders | 8 | 0.2% |
| Global Wood Trimmed Manager's Task Chair, Khaki | 8 | 0.2% |
| Staple remover | 8 | 0.2% |
| Logitech Desktop MK120 Mouse and keyboard Combo | 7 | 0.2% |
| Adjustable Depth Letter/Legal Cart | 7 | 0.2% |
| Sterilite Officeware Hinged File Box | 7 | 0.2% |
| Other values (1501) | 3213 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| xerox | 292 | 1.6% |
| x | 220 | 1.2% |
| 202 | 1.1% | |
| with | 190 | 1.0% |
| for | 183 | 1.0% |
| binders | 178 | 1.0% |
| avery | 173 | 0.9% |
| chair | 151 | 0.8% |
| black | 147 | 0.8% |
| phone | 114 | 0.6% |
| Other values (2479) | 16721 |
Most occurring characters
| Value | Count | Frequency (%) |
| 15134 | 12.3% | |
| e | 11264 | 9.2% |
| r | 6984 | 5.7% |
| o | 6626 | 5.4% |
| a | 6392 | 5.2% |
| i | 6207 | 5.1% |
| l | 5439 | 4.4% |
| n | 5044 | 4.1% |
| s | 4940 | 4.0% |
| t | 4800 | 3.9% |
| Other values (74) | 49884 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 79386 | |
| Uppercase Letter | 18619 | 15.2% |
| Space Separator | 15275 | 12.4% |
| Decimal Number | 5948 | 4.8% |
| Other Punctuation | 2415 | 2.0% |
| Dash Punctuation | 985 | 0.8% |
| Final Punctuation | 24 | < 0.1% |
| Open Punctuation | 21 | < 0.1% |
| Close Punctuation | 21 | < 0.1% |
| Math Symbol | 9 | < 0.1% |
| Other values (2) | 11 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 11264 | |
| r | 6984 | 8.8% |
| o | 6626 | 8.3% |
| a | 6392 | 8.1% |
| i | 6207 | 7.8% |
| l | 5439 | 6.9% |
| n | 5044 | 6.4% |
| s | 4940 | 6.2% |
| t | 4800 | 6.0% |
| c | 2950 | 3.7% |
| Other values (18) | 18740 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2071 | 11.1% |
| C | 2026 | 10.9% |
| B | 1851 | 9.9% |
| P | 1616 | 8.7% |
| M | 1037 | 5.6% |
| D | 985 | 5.3% |
| A | 925 | 5.0% |
| T | 878 | 4.7% |
| F | 878 | 4.7% |
| L | 747 | 4.0% |
| Other values (16) | 5605 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1054 | |
| / | 557 | |
| " | 412 | 17.1% |
| . | 177 | 7.3% |
| & | 90 | 3.7% |
| ' | 76 | 3.1% |
| # | 28 | 1.2% |
| % | 12 | 0.5% |
| ! | 5 | 0.2% |
| ; | 2 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1216 | |
| 0 | 977 | |
| 2 | 769 | |
| 4 | 568 | |
| 3 | 513 | |
| 5 | 477 | 8.0% |
| 8 | 417 | 7.0% |
| 9 | 397 | 6.7% |
| 6 | 318 | 5.3% |
| 7 | 296 | 5.0% |
Space Separator
| Value | Count | Frequency (%) |
| 15134 | ||
| 141 | 0.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 985 |
Final Punctuation
| Value | Count | Frequency (%) |
| ” | 24 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 21 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 21 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 9 |
Initial Punctuation
| Value | Count | Frequency (%) |
| “ | 8 |
Other Number
| Value | Count | Frequency (%) |
| ¾ | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 98005 | |
| Common | 24709 | 20.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 11264 | 11.5% |
| r | 6984 | 7.1% |
| o | 6626 | 6.8% |
| a | 6392 | 6.5% |
| i | 6207 | 6.3% |
| l | 5439 | 5.5% |
| n | 5044 | 5.1% |
| s | 4940 | 5.0% |
| t | 4800 | 4.9% |
| c | 2950 | 3.0% |
| Other values (44) | 37359 |
Common
| Value | Count | Frequency (%) |
| 15134 | ||
| 1 | 1216 | 4.9% |
| , | 1054 | 4.3% |
| - | 985 | 4.0% |
| 0 | 977 | 4.0% |
| 2 | 769 | 3.1% |
| 4 | 568 | 2.3% |
| / | 557 | 2.3% |
| 3 | 513 | 2.1% |
| 5 | 477 | 1.9% |
| Other values (20) | 2459 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 122531 | |
| None | 151 | 0.1% |
| Punctuation | 32 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 15134 | 12.4% | |
| e | 11264 | 9.2% |
| r | 6984 | 5.7% |
| o | 6626 | 5.4% |
| a | 6392 | 5.2% |
| i | 6207 | 5.1% |
| l | 5439 | 4.4% |
| n | 5044 | 4.1% |
| s | 4940 | 4.0% |
| t | 4800 | 3.9% |
| Other values (68) | 49701 |
None
| Value | Count | Frequency (%) |
| 141 | ||
| é | 6 | 4.0% |
| ¾ | 3 | 2.0% |
| à | 1 | 0.7% |
Punctuation
| Value | Count | Frequency (%) |
| ” | 24 | |
| “ | 8 | 25.0% |
Sales
Real number (ℝ)
| Distinct | 2623 |
|---|---|
| Distinct (%) | 79.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 221.38142 |
| Minimum | 0.444 |
|---|---|
| Maximum | 13999.96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 5.106 |
| Q1 | 17.018 |
| median | 53.81 |
| Q3 | 205.1057 |
| 95-th percentile | 907.643 |
| Maximum | 13999.96 |
| Range | 13999.516 |
| Interquartile range (IQR) | 188.0877 |
Descriptive statistics
| Standard deviation | 585.25753 |
|---|---|
| Coefficient of variation (CV) | 2.6436615 |
| Kurtosis | 179.3055 |
| Mean | 221.38142 |
| Median Absolute Deviation (MAD) | 44.488 |
| Skewness | 10.554726 |
| Sum | 733215.26 |
| Variance | 342526.38 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12.96 | 20 | 0.6% |
| 15.552 | 14 | 0.4% |
| 19.44 | 13 | 0.4% |
| 20.736 | 12 | 0.4% |
| 10.368 | 11 | 0.3% |
| 25.92 | 9 | 0.3% |
| 32.4 | 6 | 0.2% |
| 18.24 | 6 | 0.2% |
| 6.48 | 5 | 0.2% |
| 8.64 | 5 | 0.2% |
| Other values (2613) | 3211 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | |
| 0.556 | 1 | |
| 0.99 | 1 | |
| 1.08 | 1 | |
| 1.188 | 1 | |
| 1.188 | 2 | |
| 1.248 | 2 | |
| 1.392 | 1 | |
| 1.408 | 1 | |
| 1.44 | 1 |
| Value | Count | Frequency (%) |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 7999.98 | 1 | |
| 5443.96 | 1 | |
| 5199.96 | 1 | |
| 5083.96 | 1 | |
| 4799.984 | 1 | |
| 4663.736 | 1 | |
| 4416.174 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7669082 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2217761 |
|---|---|
| Coefficient of variation (CV) | 0.58981424 |
| Kurtosis | 1.7937415 |
| Mean | 3.7669082 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2239691 |
| Sum | 12476 |
| Variance | 4.9362891 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 2 | 781 | |
| 3 | 759 | |
| 5 | 441 | |
| 4 | 398 | |
| 1 | 337 | |
| 7 | 190 | 5.7% |
| 6 | 173 | 5.2% |
| 8 | 99 | 3.0% |
| 9 | 80 | 2.4% |
| 10 | 18 | 0.5% |
| Other values (4) | 36 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 337 | |
| 2 | 781 | |
| 3 | 759 | |
| 4 | 398 | |
| 5 | 441 | |
| 6 | 173 | 5.2% |
| 7 | 190 | 5.7% |
| 8 | 99 | 3.0% |
| 9 | 80 | 2.4% |
| 10 | 18 | 0.5% |
| Value | Count | Frequency (%) |
| 14 | 8 | 0.2% |
| 13 | 8 | 0.2% |
| 12 | 7 | 0.2% |
| 11 | 13 | 0.4% |
| 10 | 18 | 0.5% |
| 9 | 80 | 2.4% |
| 8 | 99 | 3.0% |
| 7 | 190 | |
| 6 | 173 | 5.2% |
| 5 | 441 |
Discount
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15646739 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 1590 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20742912 |
|---|---|
| Coefficient of variation (CV) | 1.3257019 |
| Kurtosis | 2.4619831 |
| Mean | 0.15646739 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6998317 |
| Sum | 518.22 |
| Variance | 0.04302684 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 1590 | |
| 0.2 | 1223 | |
| 0.7 | 138 | 4.2% |
| 0.8 | 107 | 3.2% |
| 0.4 | 69 | 2.1% |
| 0.3 | 68 | 2.1% |
| 0.6 | 39 | 1.2% |
| 0.1 | 28 | 0.8% |
| 0.5 | 19 | 0.6% |
| 0.15 | 16 | 0.5% |
| Other values (2) | 15 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 1590 | |
| 0.1 | 28 | 0.8% |
| 0.15 | 16 | 0.5% |
| 0.2 | 1223 | |
| 0.3 | 68 | 2.1% |
| 0.32 | 11 | 0.3% |
| 0.4 | 69 | 2.1% |
| 0.45 | 4 | 0.1% |
| 0.5 | 19 | 0.6% |
| 0.6 | 39 | 1.2% |
| Value | Count | Frequency (%) |
| 0.8 | 107 | 3.2% |
| 0.7 | 138 | 4.2% |
| 0.6 | 39 | 1.2% |
| 0.5 | 19 | 0.6% |
| 0.45 | 4 | 0.1% |
| 0.4 | 69 | 2.1% |
| 0.32 | 11 | 0.3% |
| 0.3 | 68 | 2.1% |
| 0.2 | 1223 | |
| 0.15 | 16 | 0.5% |
Profit
Real number (ℝ)
| Distinct | 2913 |
|---|---|
| Distinct (%) | 88.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.21234 |
| Minimum | -3839.9904 |
|---|---|
| Maximum | 6719.9808 |
| Zeros | 19 |
| Zeros (%) | 0.6% |
| Negative | 620 |
| Negative (%) | 18.7% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | -3839.9904 |
|---|---|
| 5-th percentile | -52.39104 |
| Q1 | 1.7632 |
| median | 8.2968 |
| Q3 | 28.315125 |
| 95-th percentile | 163.80095 |
| Maximum | 6719.9808 |
| Range | 10559.971 |
| Interquartile range (IQR) | 26.551925 |
Descriptive statistics
| Standard deviation | 241.86434 |
|---|---|
| Coefficient of variation (CV) | 8.5729983 |
| Kurtosis | 300.45368 |
| Mean | 28.21234 |
| Median Absolute Deviation (MAD) | 10.7688 |
| Skewness | 8.2171767 |
| Sum | 93439.27 |
| Variance | 58498.36 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 19 | 0.6% |
| 6.2208 | 16 | 0.5% |
| 9.3312 | 13 | 0.4% |
| 7.2576 | 12 | 0.4% |
| 5.4432 | 11 | 0.3% |
| 3.6288 | 9 | 0.3% |
| 12.4416 | 7 | 0.2% |
| 15.552 | 6 | 0.2% |
| 114.9385 | 4 | 0.1% |
| 9.072 | 4 | 0.1% |
| Other values (2903) | 3211 |
| Value | Count | Frequency (%) |
| -3839.9904 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2287.782 | 1 | |
| -1306.5504 | 1 | |
| -1237.8462 | 1 | |
| -1143.891 | 1 | |
| -1141.47 | 1 | |
| -1049.3406 | 1 | |
| -1002.7836 | 1 |
| Value | Count | Frequency (%) |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 3919.9888 | 1 | |
| 2504.2216 | 1 | |
| 1906.485 | 1 | |
| 1668.205 | 1 | |
| 1453.1238 | 1 | |
| 1439.976 | 1 | |
| 1379.977 | 1 | |
| 1351.9896 | 1 |
Order Date Year
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 2020 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 13248 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2020 |
|---|---|
| 2nd row | 2020 |
| 3rd row | 2020 |
| 4th row | 2020 |
| 5th row | 2020 |
Common Values
| Value | Count | Frequency (%) |
| 2020 | 3312 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2020 | 3312 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 6624 | |
| 0 | 6624 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 13248 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 6624 | |
| 0 | 6624 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 13248 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 6624 | |
| 0 | 6624 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13248 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 6624 | |
| 0 | 6624 |
Order Date Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7309783 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 9 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3412255 |
|---|---|
| Coefficient of variation (CV) | 0.43218664 |
| Kurtosis | -1.0050948 |
| Mean | 7.7309783 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.42971334 |
| Sum | 25605 |
| Variance | 11.163788 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 12 | 462 | |
| 9 | 459 | |
| 11 | 459 | |
| 10 | 298 | |
| 6 | 245 | |
| 5 | 242 | |
| 3 | 238 | |
| 7 | 226 | |
| 8 | 218 | |
| 4 | 203 | |
| Other values (2) | 262 |
| Value | Count | Frequency (%) |
| 1 | 155 | 4.7% |
| 2 | 107 | 3.2% |
| 3 | 238 | |
| 4 | 203 | |
| 5 | 242 | |
| 6 | 245 | |
| 7 | 226 | |
| 8 | 218 | |
| 9 | 459 | |
| 10 | 298 |
| Value | Count | Frequency (%) |
| 12 | 462 | |
| 11 | 459 | |
| 10 | 298 | |
| 9 | 459 | |
| 8 | 218 | |
| 7 | 226 | |
| 6 | 245 | |
| 5 | 242 | |
| 4 | 203 | |
| 3 | 238 |
Profit Margin
Real number (ℝ)
| Distinct | 797 |
|---|---|
| Distinct (%) | 24.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11598128 |
| Minimum | -2.75 |
|---|---|
| Maximum | 0.5 |
| Zeros | 19 |
| Zeros (%) | 0.6% |
| Negative | 620 |
| Negative (%) | 18.7% |
| Memory size | 26.0 KiB |
Quantile statistics
| Minimum | -2.75 |
|---|---|
| 5-th percentile | -0.8 |
| Q1 | 0.075 |
| median | 0.27 |
| Q3 | 0.3625 |
| 95-th percentile | 0.48 |
| Maximum | 0.5 |
| Range | 3.25 |
| Interquartile range (IQR) | 0.2875 |
Descriptive statistics
| Standard deviation | 0.48126539 |
|---|---|
| Coefficient of variation (CV) | 4.1495091 |
| Kurtosis | 10.442779 |
| Mean | 0.11598128 |
| Median Absolute Deviation (MAD) | 0.16 |
| Skewness | -2.9579568 |
| Sum | 384.13001 |
| Variance | 0.23161637 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.48 | 74 | 2.2% |
| 0.48 | 71 | 2.1% |
| 0.35 | 69 | 2.1% |
| 0.26 | 68 | 2.1% |
| 0.49 | 61 | 1.8% |
| 0.47 | 55 | 1.7% |
| 0.46 | 52 | 1.6% |
| 0.5 | 52 | 1.6% |
| 0.35 | 51 | 1.5% |
| 0.27 | 44 | 1.3% |
| Other values (787) | 2715 |
| Value | Count | Frequency (%) |
| -2.75 | 2 | |
| -2.7 | 2 | |
| -2.7 | 1 | < 0.1% |
| -2.7 | 3 | |
| -2.65 | 2 | |
| -2.6 | 2 | |
| -2.6 | 1 | < 0.1% |
| -2.55 | 2 | |
| -2.55 | 3 | |
| -2.55 | 2 |
| Value | Count | Frequency (%) |
| 0.5 | 52 | |
| 0.49 | 5 | 0.2% |
| 0.49 | 30 | |
| 0.49 | 61 | |
| 0.49 | 9 | 0.3% |
| 0.48 | 5 | 0.2% |
| 0.48 | 71 | |
| 0.48 | 74 | |
| 0.48 | 21 | 0.6% |
| 0.48 | 3 | 0.1% |
| Row ID | Postal Code | Sales | Quantity | Discount | Profit | Order Date Month | Profit Margin | Ship Mode | Segment | State | Region | Category | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Row ID | 1.000 | 0.007 | 0.013 | 0.010 | 0.029 | -0.028 | -0.053 | -0.041 | 0.065 | 0.101 | 0.159 | 0.071 | 0.024 | 0.000 |
| Postal Code | 0.007 | 1.000 | 0.006 | 0.026 | 0.021 | 0.017 | -0.026 | -0.007 | 0.050 | 0.066 | 0.959 | 0.939 | 0.032 | 0.022 |
| Sales | 0.013 | 0.006 | 1.000 | 0.317 | -0.071 | 0.517 | 0.005 | -0.190 | 0.040 | 0.022 | 0.049 | 0.000 | 0.083 | 0.215 |
| Quantity | 0.010 | 0.026 | 0.317 | 1.000 | -0.006 | 0.242 | 0.015 | 0.031 | 0.007 | 0.014 | 0.000 | 0.000 | 0.045 | 0.034 |
| Discount | 0.029 | 0.021 | -0.071 | -0.006 | 1.000 | -0.553 | 0.001 | -0.638 | 0.045 | 0.000 | 0.348 | 0.292 | 0.371 | 0.349 |
| Profit | -0.028 | 0.017 | 0.517 | 0.242 | -0.553 | 1.000 | 0.001 | 0.512 | 0.021 | 0.000 | 0.024 | 0.012 | 0.064 | 0.165 |
| Order Date Month | -0.053 | -0.026 | 0.005 | 0.015 | 0.001 | 0.001 | 1.000 | 0.015 | 0.091 | 0.074 | 0.164 | 0.068 | 0.022 | 0.015 |
| Profit Margin | -0.041 | -0.007 | -0.190 | 0.031 | -0.638 | 0.512 | 0.015 | 1.000 | 0.009 | 0.000 | 0.214 | 0.202 | 0.264 | 0.307 |
| Ship Mode | 0.065 | 0.050 | 0.040 | 0.007 | 0.045 | 0.021 | 0.091 | 0.009 | 1.000 | 0.031 | 0.172 | 0.023 | 0.000 | 0.000 |
| Segment | 0.101 | 0.066 | 0.022 | 0.014 | 0.000 | 0.000 | 0.074 | 0.000 | 0.031 | 1.000 | 0.161 | 0.018 | 0.000 | 0.053 |
| State | 0.159 | 0.959 | 0.049 | 0.000 | 0.348 | 0.024 | 0.164 | 0.214 | 0.172 | 0.161 | 1.000 | 0.993 | 0.000 | 0.016 |
| Region | 0.071 | 0.939 | 0.000 | 0.000 | 0.292 | 0.012 | 0.068 | 0.202 | 0.023 | 0.018 | 0.993 | 1.000 | 0.015 | 0.000 |
| Category | 0.024 | 0.032 | 0.083 | 0.045 | 0.371 | 0.064 | 0.022 | 0.264 | 0.000 | 0.000 | 0.000 | 0.015 | 1.000 | 0.998 |
| Sub-Category | 0.000 | 0.022 | 0.215 | 0.034 | 0.349 | 0.165 | 0.015 | 0.307 | 0.000 | 0.053 | 0.016 | 0.000 | 0.998 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Row ID | Order ID | Order Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Order Date Year | Order Date Month | Profit Margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 13 | CA-2017-114412 | 2020-04-15 | Standard Class | AA-10480 | Andrew Allen | Consumer | United States | Concord | North Carolina | 28027 | South | OFF-PA-10002365 | Office Supplies | Paper | Xerox 1967 | 15.552 | 3 | 0.2 | 5.4432 | 2020 | 4 | 0.350000 |
| 1 | 24 | US-2017-156909 | 2020-07-16 | Second Class | SF-20065 | Sandra Flanagan | Consumer | United States | Philadelphia | Pennsylvania | 19140 | East | FUR-CH-10002774 | Furniture | Chairs | Global Deluxe Stacking Chair, Gray | 71.372 | 2 | 0.3 | -1.0196 | 2020 | 7 | -0.014286 |
| 2 | 35 | CA-2017-107727 | 2020-10-19 | Second Class | MA-17560 | Matt Abelman | Home Office | United States | Houston | Texas | 77095 | Central | OFF-PA-10000249 | Office Supplies | Paper | Easy-staple paper | 29.472 | 3 | 0.2 | 9.9468 | 2020 | 10 | 0.337500 |
| 3 | 42 | CA-2017-120999 | 2020-09-10 | Standard Class | LC-16930 | Linda Cazamias | Corporate | United States | Naperville | Illinois | 60540 | Central | TEC-PH-10004093 | Technology | Phones | Panasonic Kx-TS550 | 147.168 | 4 | 0.2 | 16.5564 | 2020 | 9 | 0.112500 |
| 4 | 44 | CA-2017-139619 | 2020-09-19 | Standard Class | ES-14080 | Erin Smith | Corporate | United States | Melbourne | Florida | 32935 | South | OFF-ST-10003282 | Office Supplies | Storage | Advantus 10-Drawer Portable Organizer, Chrome Metal Frame, Smoke Drawers | 95.616 | 2 | 0.2 | 9.5616 | 2020 | 9 | 0.100000 |
| 5 | 72 | CA-2017-114440 | 2020-09-14 | Second Class | TB-21520 | Tracy Blumstein | Consumer | United States | Jackson | Michigan | 49201 | Central | OFF-PA-10004675 | Office Supplies | Paper | Telephone Message Books with Fax/Mobile Section, 5 1/2" x 3 3/16" | 19.050 | 3 | 0.0 | 8.7630 | 2020 | 9 | 0.460000 |
| 6 | 76 | US-2017-118038 | 2020-12-09 | First Class | KB-16600 | Ken Brennan | Corporate | United States | Houston | Texas | 77041 | Central | OFF-BI-10004182 | Office Supplies | Binders | Economy Binders | 1.248 | 3 | 0.8 | -1.9344 | 2020 | 12 | -1.550000 |
| 7 | 77 | US-2017-118038 | 2020-12-09 | First Class | KB-16600 | Ken Brennan | Corporate | United States | Houston | Texas | 77041 | Central | FUR-FU-10000260 | Furniture | Furnishings | 6" Cubicle Wall Clock, Black | 9.708 | 3 | 0.6 | -5.8248 | 2020 | 12 | -0.600000 |
| 8 | 78 | US-2017-118038 | 2020-12-09 | First Class | KB-16600 | Ken Brennan | Corporate | United States | Houston | Texas | 77041 | Central | OFF-ST-10000615 | Office Supplies | Storage | SimpliFile Personal File, Black Granite, 15w x 6-15/16d x 11-1/4h | 27.240 | 3 | 0.2 | 2.7240 | 2020 | 12 | 0.100000 |
| 9 | 85 | US-2017-119662 | 2020-11-13 | First Class | CS-12400 | Christopher Schild | Home Office | United States | Chicago | Illinois | 60623 | Central | OFF-ST-10003656 | Office Supplies | Storage | Safco Industrial Wire Shelving | 230.376 | 3 | 0.2 | -48.9549 | 2020 | 11 | -0.212500 |
| Row ID | Order ID | Order Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Order Date Year | Order Date Month | Profit Margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3302 | 9968 | CA-2017-153871 | 2020-12-11 | Standard Class | RB-19435 | Richard Bierner | Consumer | United States | Plainfield | New Jersey | 7060 | East | OFF-BI-10004209 | Office Supplies | Binders | Fellowes Twister Kit, Gray/Clear, 3/pkg | 40.200 | 5 | 0.0 | 18.0900 | 2020 | 12 | 0.450 |
| 3303 | 9969 | CA-2017-153871 | 2020-12-11 | Standard Class | RB-19435 | Richard Bierner | Consumer | United States | Plainfield | New Jersey | 7060 | East | OFF-BI-10004600 | Office Supplies | Binders | Ibico Ibimaster 300 Manual Binding System | 735.980 | 2 | 0.0 | 331.1910 | 2020 | 12 | 0.450 |
| 3304 | 9970 | CA-2017-153871 | 2020-12-11 | Standard Class | RB-19435 | Richard Bierner | Consumer | United States | Plainfield | New Jersey | 7060 | East | OFF-AP-10003622 | Office Supplies | Appliances | Bravo II Megaboss 12-Amp Hard Body Upright, Replacement Belts, 2 Belts per Pack | 22.750 | 7 | 0.0 | 6.5975 | 2020 | 12 | 0.290 |
| 3305 | 9982 | CA-2017-163566 | 2020-08-03 | First Class | TB-21055 | Ted Butterfield | Consumer | United States | Fairfield | Ohio | 45014 | East | OFF-LA-10004484 | Office Supplies | Labels | Avery 476 | 16.520 | 5 | 0.2 | 5.3690 | 2020 | 8 | 0.325 |
| 3306 | 9988 | CA-2017-163629 | 2020-11-17 | Standard Class | RA-19885 | Ruben Ausman | Corporate | United States | Athens | Georgia | 30605 | South | TEC-AC-10001539 | Technology | Accessories | Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology | 79.990 | 1 | 0.0 | 28.7964 | 2020 | 11 | 0.360 |
| 3307 | 9989 | CA-2017-163629 | 2020-11-17 | Standard Class | RA-19885 | Ruben Ausman | Corporate | United States | Athens | Georgia | 30605 | South | TEC-PH-10004006 | Technology | Phones | Panasonic KX - TS880B Telephone | 206.100 | 5 | 0.0 | 55.6470 | 2020 | 11 | 0.270 |
| 3308 | 9991 | CA-2017-121258 | 2020-02-26 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | FUR-FU-10000747 | Furniture | Furnishings | Tenex B1-RE Series Chair Mats for Low Pile Carpets | 91.960 | 2 | 0.0 | 15.6332 | 2020 | 2 | 0.170 |
| 3309 | 9992 | CA-2017-121258 | 2020-02-26 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | TEC-PH-10003645 | Technology | Phones | Aastra 57i VoIP phone | 258.576 | 2 | 0.2 | 19.3932 | 2020 | 2 | 0.075 |
| 3310 | 9993 | CA-2017-121258 | 2020-02-26 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | OFF-PA-10004041 | Office Supplies | Paper | It's Hot Message Books with Stickers, 2 3/4" x 5" | 29.600 | 4 | 0.0 | 13.3200 | 2020 | 2 | 0.450 |
| 3311 | 9994 | CA-2017-119914 | 2020-05-04 | Second Class | CC-12220 | Chris Cortes | Consumer | United States | Westminster | California | 92683 | West | OFF-AP-10002684 | Office Supplies | Appliances | Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection | 243.160 | 2 | 0.0 | 72.9480 | 2020 | 5 | 0.300 |